Pandas Profiling Report

Dataset statistics

Number of variables	70
Number of observations	260601
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	73.1 MiB
Average record size in memory	294.0 B

Variable types

BOOL	60
NUM	9
CAT	1

Warnings

`building_id` has unique values	Unique
`geo_level_1_id` has 4011 (1.5%) zeros	Zeros
`age` has 26041 (10.0%) zeros	Zeros
`count_families` has 20862 (8.0%) zeros	Zeros

Reproduction

Analysis started	2020-09-29 03:17:06.759523
Analysis finished	2020-09-29 03:19:35.431822
Duration	2 minutes and 28.67 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

building_id
Real number (ℝ_≥0)

UNIQUE

Distinct	260601
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	525675.4828
Minimum	4
Maximum	1052934
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	4
5-th percentile	52114
Q1	261190
median	525757
Q3	789762
95-th percentile	1000724
Maximum	1052934
Range	1052930
Interquartile range (IQR)	528572

Descriptive statistics

Standard deviation	304544.999
Coefficient of variation (CV)	0.5793403136
Kurtosis	-1.203878964
Mean	525675.4828
Median Absolute Deviation (MAD)	264277
Skewness	0.001882356737
Sum	1.369915565e+11
Variance	9.274765644e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1052670	1	< 0.1%
847304	1	< 0.1%
368102	1	< 0.1%
729986	1	< 0.1%
900578	1	< 0.1%
896480	1	< 0.1%
808415	1	< 0.1%
812505	1	< 0.1%
290264	1	< 0.1%
269782	1	< 0.1%
Other values (260591)	260591	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1	< 0.1%
8	1	< 0.1%
12	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%

Value	Count	Frequency (%)
1052934	1	< 0.1%
1052931	1	< 0.1%
1052929	1	< 0.1%
1052926	1	< 0.1%
1052921	1	< 0.1%

geo_level_1_id
Real number (ℝ_≥0)

ZEROS

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13.90035341
Minimum	0
Maximum	30
Zeros	4011
Zeros (%)	1.5%
Memory size	2.0 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	7
median	12
Q3	21
95-th percentile	27
Maximum	30
Range	30
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.033616625
Coefficient of variation (CV)	0.5779433361
Kurtosis	-1.213248785
Mean	13.90035341
Median Absolute Deviation (MAD)	6
Skewness	0.2725303548
Sum	3622446
Variance	64.53899608
Monotocity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
6	24381	9.4%
26	22615	8.7%
10	22079	8.5%
17	21813	8.4%
8	19080	7.3%
7	18994	7.3%
20	17216	6.6%
21	14889	5.7%
4	14568	5.6%
27	12532	4.8%
Other values (21)	72434	27.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4011	1.5%
1	2701	1.0%
2	931	0.4%
3	7540	2.9%
4	14568	5.6%

Value	Count	Frequency (%)
30	2686	1.0%
29	396	0.2%
28	265	0.1%
27	12532	4.8%
26	22615	8.7%

geo_level_2_id
Real number (ℝ_≥0)

Distinct	1414
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	701.0746851
Minimum	0
Maximum	1427
Zeros	38
Zeros (%)	< 0.1%
Memory size	2.0 MiB

Quantile statistics

Minimum	0
5-th percentile	69
Q1	350
median	702
Q3	1050
95-th percentile	1377
Maximum	1427
Range	1427
Interquartile range (IQR)	700

Descriptive statistics

Standard deviation	412.7107336
Coefficient of variation (CV)	0.5886829782
Kurtosis	-1.188232475
Mean	701.0746851
Median Absolute Deviation (MAD)	349
Skewness	0.02895738139
Sum	182700764
Variance	170330.1496
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39	4038	1.5%
158	2520	1.0%
181	2080	0.8%
1387	2040	0.8%
157	1897	0.7%
363	1760	0.7%
463	1740	0.7%
673	1704	0.7%
533	1684	0.6%
883	1626	0.6%
Other values (1404)	239512	91.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	38	< 0.1%
1	204	0.1%
3	77	< 0.1%
4	315	0.1%
5	25	< 0.1%

Value	Count	Frequency (%)
1427	6	< 0.1%
1426	286	0.1%
1425	466	0.2%
1424	7	< 0.1%
1423	3	< 0.1%

geo_level_3_id
Real number (ℝ_≥0)

Distinct	11595
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6257.876148
Minimum	0
Maximum	12567
Zeros	2
Zeros (%)	< 0.1%
Memory size	2.0 MiB

Quantile statistics

Minimum	0
5-th percentile	611
Q1	3073
median	6270
Q3	9412
95-th percentile	11927
Maximum	12567
Range	12567
Interquartile range (IQR)	6339

Descriptive statistics

Standard deviation	3646.369645
Coefficient of variation (CV)	0.5826848532
Kurtosis	-1.213896506
Mean	6257.876148
Median Absolute Deviation (MAD)	3171
Skewness	0.0003935120899
Sum	1630808782
Variance	13296011.59
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
633	651	0.2%
9133	647	0.2%
621	530	0.2%
11246	470	0.2%
2005	466	0.2%
11440	455	0.2%
7723	443	0.2%
9229	381	0.1%
2452	349	0.1%
12258	312	0.1%
Other values (11585)	255897	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	6	< 0.1%
3	9	< 0.1%
5	14	< 0.1%
6	21	< 0.1%

Value	Count	Frequency (%)
12567	1	< 0.1%
12565	7	< 0.1%
12564	6	< 0.1%
12563	24	< 0.1%
12562	3	< 0.1%

count_floors_pre_eq
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.129723217
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7276645453
Coefficient of variation (CV)	0.3416709456
Kurtosis	2.322597881
Mean	2.129723217
Median Absolute Deviation (MAD)	0
Skewness	0.8341129586
Sum	555008
Variance	0.5294956905
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2	156623	60.1%
3	55617	21.3%
1	40441	15.5%
4	5424	2.1%
5	2246	0.9%
6	209	0.1%
7	39	< 0.1%
9	1	< 0.1%
8	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	40441	15.5%
2	156623	60.1%
3	55617	21.3%
4	5424	2.1%
5	2246	0.9%

Value	Count	Frequency (%)
9	1	< 0.1%
8	1	< 0.1%
7	39	< 0.1%
6	209	0.1%
5	2246	0.9%

age
Real number (ℝ_≥0)

ZEROS

Distinct	42
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	26.53502865
Minimum	0
Maximum	995
Zeros	26041
Zeros (%)	10.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	15
Q3	30
95-th percentile	60
Maximum	995
Range	995
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	73.56593652
Coefficient of variation (CV)	2.772408408
Kurtosis	157.2482363
Mean	26.53502865
Median Absolute Deviation (MAD)	10
Skewness	12.19249422
Sum	6915055
Variance	5411.947016
Monotocity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
10	38896	14.9%
15	36010	13.8%
5	33697	12.9%
20	32182	12.3%
0	26041	10.0%
25	24366	9.3%
30	18028	6.9%
35	10710	4.1%
40	10559	4.1%
50	7257	2.8%
Other values (32)	22855	8.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	26041	10.0%
5	33697	12.9%
10	38896	14.9%
15	36010	13.8%
20	32182	12.3%

Value	Count	Frequency (%)
995	1390	0.5%
200	106	< 0.1%
195	2	< 0.1%
190	3	< 0.1%
185	1	< 0.1%

area_percentage
Real number (ℝ_≥0)

Distinct	84
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.018050583
Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	5
median	7
Q3	9
95-th percentile	16
Maximum	100
Range	99
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.392230936
Coefficient of variation (CV)	0.5477928694
Kurtosis	30.43825794
Mean	8.018050583
Median Absolute Deviation (MAD)	2
Skewness	3.526082314
Sum	2089512
Variance	19.29169259
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	42013	16.1%
7	36752	14.1%
5	32724	12.6%
8	28445	10.9%
9	22199	8.5%
4	19236	7.4%
10	15613	6.0%
11	13907	5.3%
3	11837	4.5%
12	7581	2.9%
Other values (74)	30294	11.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	90	< 0.1%
2	3181	1.2%
3	11837	4.5%
4	19236	7.4%
5	32724	12.6%

Value	Count	Frequency (%)
100	1	< 0.1%
96	3	< 0.1%
90	1	< 0.1%
86	5	< 0.1%
85	4	< 0.1%

height_percentage
Real number (ℝ_≥0)

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.434365179
Minimum	2
Maximum	32
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	4
median	5
Q3	6
95-th percentile	9
Maximum	32
Range	30
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.918418221
Coefficient of variation (CV)	0.3530160667
Kurtosis	14.31852616
Mean	5.434365179
Median Absolute Deviation (MAD)	1
Skewness	1.808261757
Sum	1416201
Variance	3.68032847
Monotocity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
5	78513	30.1%
6	46477	17.8%
4	37763	14.5%
7	35465	13.6%
3	25957	10.0%
8	13902	5.3%
2	9305	3.6%
9	5376	2.1%
10	4492	1.7%
11	917	0.4%
Other values (17)	2434	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	9305	3.6%
3	25957	10.0%
4	37763	14.5%
5	78513	30.1%
6	46477	17.8%

Value	Count	Frequency (%)
32	75	< 0.1%
31	1	< 0.1%
28	2	< 0.1%
26	2	< 0.1%
25	3	< 0.1%

has_superstructure_adobe_mud
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	237500
1	23101

Common Values
Chart

Value	Count	Frequency (%)
0	237500	91.1%
1	23101	8.9%

has_superstructure_mud_mortar_stone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

1	198561
0	62040

Common Values
Chart

Value	Count	Frequency (%)
1	198561	76.2%
0	62040	23.8%

has_superstructure_stone_flag
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	251654
1	8947

Common Values
Chart

Value	Count	Frequency (%)
0	251654	96.6%
1	8947	3.4%

has_superstructure_cement_mortar_stone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	255849
1	4752

Common Values
Chart

Value	Count	Frequency (%)
0	255849	98.2%
1	4752	1.8%

has_superstructure_mud_mortar_brick
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	242840
1	17761

Common Values
Chart

Value	Count	Frequency (%)
0	242840	93.2%
1	17761	6.8%

has_superstructure_cement_mortar_brick
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	240986
1	19615

Common Values
Chart

Value	Count	Frequency (%)
0	240986	92.5%
1	19615	7.5%

has_superstructure_timber
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	194151
1	66450

Common Values
Chart

Value	Count	Frequency (%)
0	194151	74.5%
1	66450	25.5%

has_superstructure_bamboo
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	238447
1	22154

Common Values
Chart

Value	Count	Frequency (%)
0	238447	91.5%
1	22154	8.5%

has_superstructure_rc_non_engineered
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	249502
1	11099

Common Values
Chart

Value	Count	Frequency (%)
0	249502	95.7%
1	11099	4.3%

has_superstructure_rc_engineered
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	256468
1	4133

Common Values
Chart

Value	Count	Frequency (%)
0	256468	98.4%
1	4133	1.6%

has_superstructure_other
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	256696
1	3905

Common Values
Chart

Value	Count	Frequency (%)
0	256696	98.5%
1	3905	1.5%

count_families
Real number (ℝ_≥0)

ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.9839486418
Minimum	0
Maximum	9
Zeros	20862
Zeros (%)	8.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4183889779
Coefficient of variation (CV)	0.425214244
Kurtosis	17.67094319
Mean	0.9839486418
Median Absolute Deviation (MAD)	0
Skewness	1.634757873
Sum	256418
Variance	0.1750493368
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	226115	86.8%
0	20862	8.0%
2	11294	4.3%
3	1802	0.7%
4	389	0.1%
5	104	< 0.1%
6	22	< 0.1%
7	7	< 0.1%
9	4	< 0.1%
8	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	20862	8.0%
1	226115	86.8%
2	11294	4.3%
3	1802	0.7%
4	389	0.1%

Value	Count	Frequency (%)
9	4	< 0.1%
8	2	< 0.1%
7	7	< 0.1%
6	22	< 0.1%
5	104	< 0.1%

has_secondary_use
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	231445
1	29156

Common Values
Chart

Value	Count	Frequency (%)
0	231445	88.8%
1	29156	11.2%

has_secondary_use_agriculture
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	243824
1	16777

Common Values
Chart

Value	Count	Frequency (%)
0	243824	93.6%
1	16777	6.4%

has_secondary_use_hotel
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	251838
1	8763

Common Values
Chart

Value	Count	Frequency (%)
0	251838	96.6%
1	8763	3.4%

has_secondary_use_rental
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	258490
1	2111

Common Values
Chart

Value	Count	Frequency (%)
0	258490	99.2%
1	2111	0.8%

has_secondary_use_institution
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	260356
1	245

Common Values
Chart

Value	Count	Frequency (%)
0	260356	99.9%
1	245	0.1%

has_secondary_use_school
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	260507
1	94

Common Values
Chart

Value	Count	Frequency (%)
0	260507	> 99.9%
1	94	< 0.1%

has_secondary_use_industry
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	260322
1	279

Common Values
Chart

Value	Count	Frequency (%)
0	260322	99.9%
1	279	0.1%

has_secondary_use_health_post
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	260552
1	49

Common Values
Chart

Value	Count	Frequency (%)
0	260552	> 99.9%
1	49	< 0.1%

has_secondary_use_gov_office
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	260563
1	38

Common Values
Chart

Value	Count	Frequency (%)
0	260563	> 99.9%
1	38	< 0.1%

has_secondary_use_use_police
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	260578
1	23

Common Values
Chart

Value	Count	Frequency (%)
0	260578	> 99.9%
1	23	< 0.1%

has_secondary_use_other
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

0	259267
1	1334

Common Values
Chart

Value	Count	Frequency (%)
0	259267	99.5%
1	1334	0.5%

damage_grade
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

2	148259
3	87218
1	25124

Frequencies
Length

Value	Count	Frequency (%)
2	148259	56.9%
3	87218	33.5%
1	25124	9.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

land_surface_condition_n
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	225073
1	35528

Common Values
Chart

Value	Count	Frequency (%)
0	225073	86.4%
1	35528	13.6%

land_surface_condition_o
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	252285
1	8316

Common Values
Chart

Value	Count	Frequency (%)
0	252285	96.8%
1	8316	3.2%

land_surface_condition_t
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	216757
0	43844

Common Values
Chart

Value	Count	Frequency (%)
1	216757	83.2%
0	43844	16.8%

foundation_type_h
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	259153
1	1448

Common Values
Chart

Value	Count	Frequency (%)
0	259153	99.4%
1	1448	0.6%

foundation_type_i
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	250022
1	10579

Common Values
Chart

Value	Count	Frequency (%)
0	250022	95.9%
1	10579	4.1%

foundation_type_r
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	219196
0	41405

Common Values
Chart

Value	Count	Frequency (%)
1	219196	84.1%
0	41405	15.9%

foundation_type_u
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	246341
1	14260

Common Values
Chart

Value	Count	Frequency (%)
0	246341	94.5%
1	14260	5.5%

foundation_type_w
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	245483
1	15118

Common Values
Chart

Value	Count	Frequency (%)
0	245483	94.2%
1	15118	5.8%

roof_type_n
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	182842
0	77759

Common Values
Chart

Value	Count	Frequency (%)
1	182842	70.2%
0	77759	29.8%

roof_type_q
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	199025
1	61576

Common Values
Chart

Value	Count	Frequency (%)
0	199025	76.4%
1	61576	23.6%

roof_type_x
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	244418
1	16183

Common Values
Chart

Value	Count	Frequency (%)
0	244418	93.8%
1	16183	6.2%

ground_floor_type_f
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	209619
0	50982

Common Values
Chart

Value	Count	Frequency (%)
1	209619	80.4%
0	50982	19.6%

ground_floor_type_m
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260093
1	508

Common Values
Chart

Value	Count	Frequency (%)
0	260093	99.8%
1	508	0.2%

ground_floor_type_v
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	236008
1	24593

Common Values
Chart

Value	Count	Frequency (%)
0	236008	90.6%
1	24593	9.4%

ground_floor_type_x
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	235724
1	24877

Common Values
Chart

Value	Count	Frequency (%)
0	235724	90.5%
1	24877	9.5%

ground_floor_type_z
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	259597
1	1004

Common Values
Chart

Value	Count	Frequency (%)
0	259597	99.6%
1	1004	0.4%

other_floor_type_j
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	220758
1	39843

Common Values
Chart

Value	Count	Frequency (%)
0	220758	84.7%
1	39843	15.3%

other_floor_type_q
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	165282
0	95319

Common Values
Chart

Value	Count	Frequency (%)
1	165282	63.4%
0	95319	36.6%

other_floor_type_s
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	248573
1	12028

Common Values
Chart

Value	Count	Frequency (%)
0	248573	95.4%
1	12028	4.6%

other_floor_type_x
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	217153
1	43448

Common Values
Chart

Value	Count	Frequency (%)
0	217153	83.3%
1	43448	16.7%

position_j
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	247319
1	13282

Common Values
Chart

Value	Count	Frequency (%)
0	247319	94.9%
1	13282	5.1%

position_o
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	258268
1	2333

Common Values
Chart

Value	Count	Frequency (%)
0	258268	99.1%
1	2333	0.9%

position_s
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	202090
0	58511

Common Values
Chart

Value	Count	Frequency (%)
1	202090	77.5%
0	58511	22.5%

position_t
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	217705
1	42896

Common Values
Chart

Value	Count	Frequency (%)
0	217705	83.5%
1	42896	16.5%

plan_configuration_a
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260349
1	252

Common Values
Chart

Value	Count	Frequency (%)
0	260349	99.9%
1	252	0.1%

plan_configuration_c
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260276
1	325

Common Values
Chart

Value	Count	Frequency (%)
0	260276	99.9%
1	325	0.1%

plan_configuration_d
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	250072
0	10529

Common Values
Chart

Value	Count	Frequency (%)
1	250072	96.0%
0	10529	4.0%

plan_configuration_f
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260579
1	22

Common Values
Chart

Value	Count	Frequency (%)
0	260579	> 99.9%
1	22	< 0.1%

plan_configuration_m
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260555
1	46

Common Values
Chart

Value	Count	Frequency (%)
0	260555	> 99.9%
1	46	< 0.1%

plan_configuration_n
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260563
1	38

Common Values
Chart

Value	Count	Frequency (%)
0	260563	> 99.9%
1	38	< 0.1%

plan_configuration_o
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260442
1	159

Common Values
Chart

Value	Count	Frequency (%)
0	260442	99.9%
1	159	0.1%

plan_configuration_q
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	254909
1	5692

Common Values
Chart

Value	Count	Frequency (%)
0	254909	97.8%
1	5692	2.2%

plan_configuration_s
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	260255
1	346

Common Values
Chart

Value	Count	Frequency (%)
0	260255	99.9%
1	346	0.1%

plan_configuration_u
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	256952
1	3649

Common Values
Chart

Value	Count	Frequency (%)
0	256952	98.6%
1	3649	1.4%

legal_ownership_status_a
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	255089
1	5512

Common Values
Chart

Value	Count	Frequency (%)
0	255089	97.9%
1	5512	2.1%

legal_ownership_status_r
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	259128
1	1473

Common Values
Chart

Value	Count	Frequency (%)
0	259128	99.4%
1	1473	0.6%

legal_ownership_status_v
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

1	250939
0	9662

Common Values
Chart

Value	Count	Frequency (%)
1	250939	96.3%
0	9662	3.7%

legal_ownership_status_w
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	254.5 KiB

0	257924
1	2677

Common Values
Chart

Value	Count	Frequency (%)
0	257924	99.0%
1	2677	1.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	building_id	geo_level_1_id	geo_level_2_id	geo_level_3_id	count_floors_pre_eq	age	area_percentage	height_percentage	has_superstructure_adobe_mud	has_superstructure_mud_mortar_stone	has_superstructure_cement_mortar_brick	has_superstructure_timber	has_superstructure_bamboo	count_families	has_secondary_use	has_secondary_use_agriculture	damage_grade	land_surface_condition_n	land_surface_condition_o	land_surface_condition_t	foundation_type_i	foundation_type_r	foundation_type_w	roof_type_n	roof_type_q	ground_floor_type_f	ground_floor_type_v	ground_floor_type_x	other_floor_type_j	other_floor_type_q	other_floor_type_x	position_s	position_t	plan_configuration_d	plan_configuration_u	legal_ownership_status_v
0	802906	6	487	12198	2	30	6	5	1	1	0	0	0	1	0	0	3	0	0	1	0	1	0	1	0	1	0	0	0	1	0	0	1	1	0	1
1	28830	8	900	2812	2	10	8	7	0	1	0	0	0	1	0	0	2	0	1	0	0	1	0	1	0	0	0	1	0	1	0	1	0	1	0	1
2	94947	21	363	8973	2	10	5	5	0	1	0	0	0	1	0	0	3	0	0	1	0	1	0	1	0	1	0	0	0	0	1	0	1	1	0	1
3	590882	22	418	10694	2	10	6	5	0	1	0	1	1	1	0	0	2	0	0	1	0	1	0	1	0	1	0	0	0	0	1	1	0	1	0	1
4	201944	11	131	1488	3	30	8	9	1	0	0	0	0	1	0	0	3	0	0	1	0	1	0	1	0	1	0	0	0	0	1	1	0	1	0	1
5	333020	8	558	6089	2	10	9	5	0	1	0	0	0	1	1	1	2	0	0	1	0	1	0	1	0	1	0	0	0	1	0	1	0	1	0	1
6	728451	9	475	12066	2	25	3	4	0	1	0	0	0	1	0	0	3	1	0	0	0	1	0	1	0	0	0	1	0	1	0	1	0	1	0	1
7	475515	20	323	12236	2	0	8	6	0	0	1	1	0	1	0	0	1	0	0	1	0	0	1	0	1	0	1	0	0	0	1	1	0	0	1	1
8	441126	0	757	7219	2	15	8	6	0	1	0	1	0	1	0	0	2	0	0	1	0	1	0	0	1	1	0	0	0	1	0	1	0	1	0	1
9	989500	26	886	994	1	0	13	4	0	0	1	0	0	1	0	0	1	0	0	1	1	0	0	1	0	0	1	0	1	0	0	1	0	1	0	1

Last rows

	building_id	geo_level_1_id	geo_level_2_id	geo_level_3_id	count_floors_pre_eq	age	area_percentage	height_percentage	has_superstructure_mud_mortar_stone	has_superstructure_mud_mortar_brick	has_superstructure_cement_mortar_brick	has_superstructure_timber	count_families	has_secondary_use	has_secondary_use_agriculture	damage_grade	land_surface_condition_n	land_surface_condition_t	foundation_type_r	roof_type_n	roof_type_q	roof_type_x	ground_floor_type_f	ground_floor_type_v	other_floor_type_j	other_floor_type_q	other_floor_type_s	other_floor_type_x	position_j	position_s	plan_configuration_d	plan_configuration_q	legal_ownership_status_v
260591	560805	20	368	5980	1	25	5	3	1	0	0	0	1	1	1	3	1	0	1	1	0	0	1	0	1	0	0	0	0	1	1	0	1
260592	207683	10	1382	1903	2	25	5	5	1	0	0	1	1	0	0	2	0	1	1	1	0	0	1	0	0	1	0	0	0	1	1	0	1
260593	226421	8	767	8613	2	5	13	5	1	0	0	0	1	1	1	2	0	1	1	1	0	0	1	0	0	1	0	0	0	1	1	0	1
260594	159555	27	181	1537	6	0	13	12	0	1	0	0	1	0	0	2	0	1	1	1	0	0	1	0	0	0	0	1	1	0	1	0	1
260595	827012	8	268	4718	2	20	8	5	1	0	0	0	1	0	0	3	0	1	1	1	0	0	1	0	0	1	0	0	0	1	1	0	1
260596	688636	25	1335	1621	1	55	6	3	1	0	0	0	1	0	0	2	1	0	1	1	0	0	1	0	1	0	0	0	0	1	0	1	1
260597	669485	17	715	2060	2	0	6	5	1	0	0	0	1	0	0	3	0	1	1	1	0	0	1	0	0	1	0	0	0	1	1	0	1
260598	602512	17	51	8163	3	55	6	7	1	0	0	0	1	0	0	3	0	1	1	0	1	0	1	0	0	1	0	0	0	1	1	0	1
260599	151409	26	39	1851	2	10	14	6	0	0	1	0	1	0	0	2	0	1	1	0	0	1	0	1	0	0	1	0	1	0	1	0	1
260600	747594	21	9	9101	3	10	7	6	1	0	0	0	3	0	0	3	1	0	1	1	0	0	1	0	0	1	0	0	1	0	1	0	1

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows